"""
Case Type   : 系统内部使用工具
Case Name   : gs_ctl start指定-l FILENAME,文件不存在且其路径不在数据库实例目录下启动备机
              是否可以启动成功（参数后指定文件路径）
Create At   : 2021/01/18
Owner       : opentestcase015
Description :
    1.关闭运行正常的集群
    2.使用-l参数指定不在数据库实例目录下且不存在的文件启动数据库备机
    3.查看gsctl_test.dat文件中是否有记录信息
    4.查看集群状态
    5.恢复环境
Expect      :
    1.关闭运行正常的集群成功
    2.使用-l参数指定不在数据库实例目录下且不存在的文件启动数据库备机成功
    3.查看gsctl_test.dat文件中，文件中有记录信息
    4.查看集群状态
    5.成功
History     :
    Modified by lopentestcase027 2023/1/9: 优化用例步骤格式及一主两备判断方式
"""

import unittest
import os
from testcase.utils.CommonSH import CommonSH
from testcase.utils.Constant import Constant
from testcase.utils.Logger import Logger
from yat.test import Node
from yat.test import macro

LOG = Logger()
primary_sh = CommonSH('PrimaryDbUser')


@unittest.skipIf(3 != primary_sh.get_node_num(), '非1+2环境不执行')
class LogicalReplication(unittest.TestCase):
    def setUp(self):
        LOG.info(f'--------{os.path.basename(__file__)} start--------')
        self.constant = Constant()
        self.PrimaryNode = Node('PrimaryDbUser')
        self.user_node = Node('Standby1DbUser')
        self.sh_standby = CommonSH('Standby1DbUser')

    def test_system_internal_tools(self):
        LOG.info('--------step1:关闭正在运行的集群  expect:成功--------')
        is_stop = self.sh_standby.stop_db_cluster()
        self.assertTrue(is_stop)

        LOG.info('--------step2:启动数据库且-l参数指定的文件不存在  '
                 'expect:启动备机成功--------')
        excute_cmd = f'''
                    source {macro.DB_ENV_PATH};
                    gs_ctl start -D {macro.DB_INSTANCE_PATH} -M standby \
                    -l {macro.DB_BACKUP_PATH}/gsctl_test.dat; 
                        '''
        LOG.info(excute_cmd)
        msg = self.user_node.sh(excute_cmd).result()
        LOG.info(msg)
        self.assertIn(self.constant.RESTART_SUCCESS_MSG, msg)

        LOG.info('-------step3:查看gsctl_test.dat文件 expect:有记录信息-------')
        excute_cmd = f"du -h {macro.DB_BACKUP_PATH}/gsctl_test.dat"
        LOG.info(excute_cmd)
        msg = self.user_node.sh(excute_cmd).result()
        LOG.info(msg)
        res = msg.split()[0]
        self.assertTrue(float(res[:-1]) > 0)

        LOG.info('--------step4:查看集群状态 expect:备机正常启动--------')
        status = self.sh_standby.get_db_cluster_status()
        self.assertTrue(status)

    def tearDown(self):
        LOG.info('--------step5:恢复环境 expect:成功--------')
        is_start = self.sh_standby.restart_db_cluster()
        LOG.info(is_start)
        LOG.info('--------删除创建文件--------')
        excute_cmd = f"rm -rf {macro.DB_BACKUP_PATH}/gsctl_test.dat"
        LOG.info(excute_cmd)
        msg = self.user_node.sh(excute_cmd).result()
        LOG.info(msg)
        LOG.info(f'--------{os.path.basename(__file__)} end--------')
